<html>

<rel="
CREATE TRIGGER `trigger_member_insert` AFTER INSERT ON `sys_member` FOR EACH ROW BEGIN

INSERT INTO sys_member_activation 
SET member_activation_network_id = NEW.member_network_id, 
member_activation_start_date = DATE(NEW.member_join_datetime), 
member_activation_end_date = DATE_ADD(DATE(NEW.member_join_datetime), INTERVAL '1' YEAR), 
member_activation_note = 'Aktivasi Member Registrasi', 
member_activation_input_datetime = NEW.member_join_datetime, 
member_activation_input_administrator_id = 1;

END;



nambah tabel

sys_member_activation

Querynya :
"INSERT INTO sys_member_activation (member_activation_network_id, 
member_activation_start_date, 
member_activation_end_date, 
member_activation_note, 
member_activation_input_datetime, 
member_activation_input_administrator_id) 
SELECT network_id, 
DATE(member_join_datetime), 
DATE_ADD(DATE(member_join_datetime), INTERVAL 1 YEAR), 
'Aktivasi Member Registrasi (Migrasi)', 
member_join_datetime, 
1 
FROM sys_member 
INNER JOIN sys_network ON network_id = member_network_id 
WHERE network_level_status != 'passive' 
ORDER BY network_id ASC;"






/trunk/protected/modules/admin/modules/report/views/report_fee_admin
/trunk/protected/modules/admin/modules/report/views/report_fee_admin/_search.php
/trunk/protected/modules/admin/modules/report/views/report_fee_admin/view.php

/trunk/protected/modules/admin/modules/report/controllers/Report_fee_adminController.php

/trunk/protected/helpers/function_lib.php

/trunk/protected/views/site/index.php

/trunk/protected/views/login/create.php

/trunk/protected/modules/member/views/ecommerce/extend_cart.php
/trunk/protected/modules/member/views/ecommerce/extend_checkout.php
/trunk/protected/modules/member/views/ecommerce/extend_transaction.php

/trunk/protected/modules/member/views/binary/extend.php

/trunk/protected/modules/member/controllers/BinaryController.php
/trunk/protected/modules/member/controllers/EcommerceController.php
/trunk/protected/modules/member/controllers/LoginController.php
/trunk/protected/modules/member/controllers/MainController.php

/trunk/protected/modules/admin/modules/system/views/member_extend/_search.php
/trunk/protected/modules/admin/modules/system/views/member_extend/paid_list.php
/trunk/protected/modules/admin/modules/system/views/member_extend/unpaid_list.php

/trunk/protected/modules/admin/modules/system/controllers/Ecommerce_transactionController.php
/trunk/protected/modules/admin/modules/system/controllers/Member_extendController.php

/trunk/protected/models/active_record/ecom_products.php

/trunk/protected/models/active_record/sys_ewallet_cut.php

/trunk/protected/models/form/login_form.php

/trunk/protected/models/form/sys_member_activation.php
/trunk/protected/models/form/sys_member_activation_request.php

/trunk/protected/controllers/LoginController.php

/trunk/protected/components/AdminController.php
/trunk/protected/components/MemberAutoIdentity.php
/trunk/protected/components/MemberIdentity.php
/trunk/themes/global/views/layouts/images/form_added_member.png
/trunk/themes/voffice-default/views/layouts/main.php
/trunk/themes/global/views/layouts/main.php
/trunk/themes/global/views/layouts/css/style.css
/trunk/themes/global/views/layouts/images/form_added_member-on.png
/trunk/themes/global/views/layouts/images/form_add_member.png
/trunk/themes/global/views/layouts/images/submit-btn.png
/trunk/protected/modules/admin/modules/system/views/member_extend
/trunk/protected/modules/admin/modules/system/views/member_extend/_search.php
/trunk/protected/modules/admin/modules/system/views/member_extend/paid_list.php
/trunk/protected/modules/admin/modules/system/views/member_extend/report_activation.php
/trunk/protected/modules/admin/modules/system/views/member_extend/unpaid_list.php
/trunk/protected/modules/admin/modules/system/controllers/Member_extendController.php
/trunk/images/icon/adm_cancel_navy.png
/trunk/images/icon/adm_checklist_navy.png
/trunk/protected/modules/admin/modules/system/controllers/Ecommerce_transactionController.php





menambahkan serial
sys_serial_products


EXT1100000000001 234567 17 2014-09-22 13:56:07

EXT2100000000001 227589 18 2014-09-24 10:27:34 0000-00-00 00:00:00

EXT3100000000001 837405 19 2014-09-24 10:27:48 0000-00-00 00:00:00


ecom_products_category

17 Product Voucher Masa Aktif 1 Tahun EXTEND EXT1

18 Product Voucher Masa Aktif 2 Tahun EXTEND EXT2

19 Product Voucher Masa Aktif 3 Tahun EXTEND EXT3


ecom_products
96 17 VC EXT 001 Voucher Perpanjangan Masa Aktif 1 tahun Voucher Perpanjangan Masa Aktif 1 Tahun 50000

97 18 VC EXT 002 Voucher Perpanjangan Masa Aktif 2 tahun Voucher Perpanjangan Masa Aktif 2 Tahun 100000

98 19 VC EXT 003 Voucher Perpanjangan Masa Aktif 3 tahun Voucher Perpanjangan Masa Aktif 3 Tahun 150000


sys_member_activation_request

nambah Menu di 
site_administrator_menu
MLM SYSTEM MENU
*data Request Perpanjangan
*data Approval Perpanjangan
*Report Perpanjangan Masa Aktif

General Report
*Report Fee Admin

nambah models/form
sys_member_activation
sys_member_activation_request

models/active_record
sys_ewallet_cut

nambah controller
views

component/AdminController

component/MemberIdentity

views/login/index



admin
system/member/controller/member_extend

system/member/views/member_extend

member
BinaryController
Ecommerce Controller


helper
function lib

member/loginControler

theme, vo , main

views/login/index.php

LoginController 

models/form/login_form

models/form/sysMemberActivationReq

views/login/create

style
core_yii\themes\global\views\layouts\css\style.css


protected/controller/login

images
core_yii\themes\global\views\layouts\images\submit-btn

member_extendController

core_yii\themes\voffice-default\views\layouts\main

yii/framework/web/auth/CbaseUserIdentity



member/views/binary/extend
member/views/ecommerce/extend_cart
member/views/ecommerce/extend_checkout
member/views/ecommerce/extend_transaction



Generate Serial
===============

awalnya
nambahi ecom_products_category
update type = EXTEND 


generate serial
insert dulu data awal, serial_product 3 row












;

?>